AmDeposit

Logical Entity Name | AmDeposit
Default Table Name | AmDeposit
Physical Only | NO
Owner | dbo
Definition |
Note |

AmDeposit Columns

ColumnName | Domain | Datatype | NULL | Definition
AmDepositID |  | int | NO |
SyStudentID |  | int | NO |
DateReceived |  | datetime | NO |
Amount |  | money | NO |
Descrip |  | varchar(30) | NO |
PaymentType |  | char(1) | NO |
SaCCID |  | int | YES |
CheckNo |  | varchar(20) | YES |
ReceiptNo |  | varchar(16) | YES |
AmRepID |  | int | NO |
Status |  | char(1) | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserID |  | int | NO |
ts |  | timestamp | NO |
AdEnrollID |  | int | YES |
CCAuthNum |  | nchar(14) | YES |
CCDeclineCode |  | nchar(14) | YES |
SaTransID |  | int | YES |
SyAddressID |  | int | YES |
AdTermID |  | int | YES |
AySeq |  | smallint | YES |
SaBillCodeID |  | int | YES |
SaSubsidiaryID |  | int | YES |
SaStudSubsidiaryID |  | int | YES |
HsStudentApplicationID |  | int | YES |
AddUserID |  | int | YES |
PostUserID |  | int | YES |
DepositType |  | smallint | YES |
SaStudentBankAccountId |  | int | YES |
BankAccountAuthNum |  | nchar(14) | YES |
BankAccountDeclineCode |  | nchar(14) | YES |
ChangedVia |  | nvarchar(2) | YES |

AmDeposit Primary and Unique Keys

Key Name | Key Type | Keys
AmDeposit_AmDepositID_U_C_IDX | PrimaryKey | AmDepositID
AmDeposit_DateReceived_AmDepositID_U_N_IDX | Index | DateReceived, AmDepositID

AmDeposit Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_AmDeposit_AddUserID_SyStaff_SyStaffID |  |  | AddUserID | NO | YES
HsStudentApplication | Non-Identifying | Zero or One to Zero or More | Fk_AmDeposit_HsStudentApplicationID_HsStudentApplication_HsStudentApplicationID |  |  | HsStudentApplicationID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_AmDeposit_PostUserID_SyStaff_SyStaffID |  |  | PostUserID | NO | YES
SaSubsidiary | Non-Identifying | Zero or One to Zero or More | Fk_AmDeposit_SaSubsidiaryID_SaSubsidiary_SaSubsidiaryID |  |  | SaSubsidiaryID | NO | YES
AdTerm | Non-Identifying | Zero or One to Zero or More | Fk_AmDeposits_AdTermid_AdTerm_AdTermID |  |  | AdTermID | NO | YES
SaBillCode | Non-Identifying | Zero or One to Zero or More | Fk_AmDeposits_SaBillCodeID_SaBillCode_SaBillCodeID |  |  | SaBillCodeID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

AmDeposit Check Constraints

Check Constraint Name | CheckConstraint

AmDeposit Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AmDeposit Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Deposit | NO |  |  |
Physical (Microsoft SQL Server) dbo.AmDeposit | NO |  |  |

AmDeposit Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Admissions

AmDeposit Data Movement Rules

Name | Type | Rule Text/Value